The Macintosh Demo Applications CD/Apple-MacintoshDemoApplicationsCD-1.0-1992.bin/More Information/GQL V3.0/Open ME! - USA Sales/Open ME! - USA Sales.rsrc/gDEM_15947_Sales by City2 (5000)

Text File | 1992-01-27 | 195b | 1 lines

select customer.cust_city, AVG (orders.ord_amount) from customer, orders where ((orders.ord_amount >= $5000)) and customer.cust_num = orders.cust_nr group by customer.cust_city order by 2 desc ;